﻿using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Common;

public partial class top_reviewnew_msgorder : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string count = string.Empty;

        for (int i = 0; i <= 43; i++)
        {
            string sql = @"SELECT COUNT(*)
	                        FROM TCS_TaobaoMsgLog 
	                        WHERE nick IN 
	                        (
		                        SELECT nick 
		                        FROM [TCS_MsgOrder] 
		                        WHERE id = {0}
	                        )
	                        AND typ = 'TradeRated' ";
            sql = sql.Replace("{0}", i.ToString());
            try
            {
                count = utils.ExecuteString(sql);
            }
            catch { }

            Response.Write("通道" + i.ToString() + "：" + count + "<br>");
        }
        Response.Write("<hr>");
        for (int i = 0; i <= 43; i++)
        {
            string sql = @"SELECT COUNT(*)
	                        FROM TCS_TaobaoMsgLog 
	                        WHERE nick IN 
	                        (
		                        SELECT nick 
		                        FROM [TCS_MsgOrder] 
		                        WHERE id = {0}
	                        )
	                        AND typ = 'TradeSellerShip' ";
            sql = sql.Replace("{0}", i.ToString());
            try
            {
                count = utils.ExecuteString(sql);
            }
            catch { }

            Response.Write("通道" + i.ToString() + "：" + count + "<br>");
        }
    }
}